﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Management.Master" CodeBehind="Default.aspx.vb" Inherits="BooksReviewApp._Default1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <h2>Management Section
    </h2>
    <div class="aside2">
        <h3>Useful Links</h3>
        <br />
        <br />
        <h4>Tutorials</h4>
        <br />
       <table style="font-size:small; width: 169px;">
            <tr>
                <td >
                    <asp:ImageButton ID="ib_" runat="server" ImageUrl="../Images/java.png"
                        PostBackUrl="http://www.tutorialspoint.com/java/" BorderStyle="None" Height="25px"/>
                </td>
                <td>
                    <asp:LinkButton ID="lb_Java" runat="server" PostBackUrl="http://www.tutorialspoint.com/java/">Java</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_Cpp" runat="server" ImageUrl="../Images/cpp_logo.png"
                        PostBackUrl="http://www.cplusplus.com/doc/tutorial/" BorderStyle="None" Height="25px"/>
                </td>
                <td>
                    <asp:LinkButton ID="lb_Cpp" runat="server" PostBackUrl="http://www.cplusplus.com/doc/tutorial/">C++</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_Csharp" runat="server" BorderStyle="None" ImageUrl="../Images/csharp.png" PostBackUrl="http://csharp.net-tutorials.com/" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_Csharp" runat="server" PostBackUrl="http://csharp.net-tutorials.com/">C#</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_Vb" runat="server" BorderStyle="None" ImageUrl="../Images/VisualBasic_2.png" PostBackUrl="http://www.visual-basic-tutorials.com/" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_Vb" runat="server" PostBackUrl="http://www.visual-basic-tutorials.com/">Visual Basic</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_ObjC" runat="server" BorderStyle="None" ImageUrl="../Images/objC.gif" PostBackUrl="https://developer.apple.com/library/mac/documentation/Cocoa/Conceptual/ProgrammingWithObjectiveC/Introduction/Introduction.html" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_ObjC" runat="server" PostBackUrl="https://developer.apple.com/library/mac/documentation/Cocoa/Conceptual/ProgrammingWithObjectiveC/Introduction/Introduction.html">Objective-C</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_Swift" runat="server" BorderStyle="None" ImageUrl="../Images/swift-hero.png" PostBackUrl="https://developer.apple.com/swift/" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_Swift" runat="server" PostBackUrl="https://developer.apple.com/swift/">Swift</asp:LinkButton>
                </td>
            </tr>
             <tr>
                <td>
                    <asp:ImageButton ID="ib_PhP" runat="server" BorderStyle="None" ImageUrl="../Images/php.png" PostBackUrl="https://php.net/" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_PhP" runat="server" PostBackUrl="https://php.net/">PHP</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_Python" runat="server" BorderStyle="None" ImageUrl="../Images/python.png" PostBackUrl="http://www.tutorialspoint.com/python/" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_Pythob" runat="server" PostBackUrl="http://www.tutorialspoint.com/python/">Python</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_Javascript" runat="server" BorderStyle="None" ImageUrl="../Images/JavaScript-logo.png" PostBackUrl="http://www.w3schools.com/js/" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_Javascript" runat="server" PostBackUrl="http://www.w3schools.com/js/">Javascript</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_Jquery" runat="server" BorderStyle="None" ImageUrl="../Images/jquery.jpg" PostBackUrl="http://jquery.com/" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_Jquery" runat="server" PostBackUrl="http://jquery.com/">JQuery</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_Html" runat="server"  BorderStyle="None" ImageUrl="../Images/HTML5_Logo_512.png" PostBackUrl="http://www.w3schools.com/html/" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_Html" runat="server" PostBackUrl="http://www.w3schools.com/html/">HTML 5</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td>
                    <asp:ImageButton ID="ib_Css" runat="server" BorderStyle="None" ImageUrl="../Images/css.jpg" PostBackUrl="http://www.w3schools.com/css//" Height="25px" />
                </td>
                <td>
                    <asp:LinkButton ID="lb_Css" runat="server" PostBackUrl="http://www.w3schools.com/css/">CSS 3</asp:LinkButton>
                </td>
            </tr>
        </table>
        <br />
    </div>
    <div class="mainDiv2">
        <div class="centered">
            <h3>User Activity</h3>
            <br />
            <p>Hello admin! These are the most active members of the website!</p>
            <br />
            
            <div class="mainDiv5">
                <asp:Chart ID="Chart2" runat="server" DataSourceID="SqlDataSource1" Height="200px"
                    Width="200px" Palette="Pastel">
                    <Series>
                        <asp:Series Name="Series1" ChartType="Pie" XValueMember="Bibliophile" YValueMembers="TotalPosts"
                            YValuesPerPoint="2">
                        </asp:Series>
                    </Series>
                    <ChartAreas>
                        <asp:ChartArea Name="ChartArea1">
                        </asp:ChartArea>
                    </ChartAreas>
                </asp:Chart>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BooksReviewDBConnectionString1 %>"
                    ProviderName="<%$ ConnectionStrings:BooksReviewDBConnectionString1.ProviderName %>" SelectCommand="SELECT * FROM [PostsByBibliophile]"></asp:SqlDataSource>
               
                <div style="margin: 0 130px">
                    <table>
                        <tr>
                            <td class="style10">
                                <asp:Image ID="Image5" runat="server" ImageUrl="../Images/book_stack_small.jpg" />
                            </td>
                            <td class="style7">
                                <asp:Image ID="Image4" runat="server" ImageUrl="../Images/book_stack_large.jpg" />
                            </td>
                            <td class="style13">
                                <asp:Image ID="Image6" runat="server" ImageUrl="../Images/admin.jpg" />
                            </td>
                        </tr>
                        <tr>
                            <td class="style11">
                                <strong>Bibliophile</strong>
                            </td>
                            <td class="style8">
                                <strong>BookWorm</strong>
                            </td>
                            <td class="style14">
                                <strong>Admin</strong>
                            </td>
                        </tr>
                        <tr>
                            <td class="style12">0 - 19 Posts
                            </td>
                            <td class="style9">20 - 39 Posts
                            </td>
                            <td class="style15">Site's Administrator
                            </td>
                        </tr>
                    </table>
                </div>

            </div>
       </div>
        <br />
       
        
        <div class="centered">
            <h3>Site Activity</h3>

            <div class="mainDiv5">
                <p>
                    <asp:Chart ID="Chart3" runat="server" DataSourceID="SqlDataSource2" Palette="Pastel"
                        Height="300px" Width="500px">
                        <Series>
                            <asp:Series Name="Series1" ChartType="Bubble" XValueMember="Activity" YValueMembers="TotalActivity"
                                YValuesPerPoint="2">
                            </asp:Series>
                        </Series>
                        <ChartAreas>
                            <asp:ChartArea Name="ChartArea1">
                            </asp:ChartArea>
                        </ChartAreas>
                    </asp:Chart>
                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:BooksReviewDBConnectionString1 %>"
                        ProviderName="<%$ ConnectionStrings:BooksReviewDBConnectionString1.ProviderName %>" SelectCommand="SELECT * FROM [TotalSiteActivity]"></asp:SqlDataSource>
                </p>
            </div>
        </div>
        <div class="centered">
            <h3>Popular Categories</h3>

            <div class="mainDiv5">
                <p>
                    <asp:Chart ID="Chart4" runat="server" DataSourceID="SqlDataSource3" Palette="Pastel" CssClass="centeredImgLeftPad">
                        <Series>
                            <asp:Series Name="Series1" XValueMember="Category" YValueMembers="TotalCategories" YValuesPerPoint="4">
                            </asp:Series>
                        </Series>
                        <ChartAreas>
                            <asp:ChartArea Name="ChartArea1">
                            </asp:ChartArea>
                        </ChartAreas>
                    </asp:Chart>
                </p>
                <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:BooksReviewDBConnectionString1 %>" SelectCommand="SELECT [Category], [TotalCategories] FROM [Categories_Most_Popular]"></asp:SqlDataSource>
            </div>
        </div>
        <div class="centered">
            <h3>Popular Sub Categories</h3>

            <div class="mainDiv5">
                <p>
                    <asp:Chart ID="Chart5" runat="server" DataSourceID="SqlDataSource4" Palette="Pastel" CssClass="centeredImgLeftPad">
                        <Series>
                            <asp:Series Name="Series1" XValueMember="SubCategory" YValueMembers="TotalSubCategories">
                            </asp:Series>
                        </Series>
                        <ChartAreas>
                            <asp:ChartArea Name="ChartArea1">
                            </asp:ChartArea>
                        </ChartAreas>
                    </asp:Chart>
                </p>
                <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:BooksReviewDBConnectionString1 %>" SelectCommand="SELECT * FROM [SubCategories_Most_Popular]"></asp:SqlDataSource>
            </div>
        </div>
        <div class="centered">
            <h3>Popular Languages</h3>

            <div class="mainDiv5">
                <br />
                <br />
                
                    <asp:Chart ID="Chart6" runat="server" DataSourceID="SqlDataSource5" Palette="Pastel" CssClass="centeredImgLeftPad">
                        <Series>
                            <asp:Series Name="Series1" XValueMember="Language" YValueMembers="TotalLanguages">
                            </asp:Series>
                        </Series>
                        <ChartAreas>
                            <asp:ChartArea Name="ChartArea1">
                            </asp:ChartArea>
                        </ChartAreas>

                    </asp:Chart>
                
                <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:BooksReviewDBConnectionString1 %>" SelectCommand="SELECT * FROM [Languages_Most_Popular]"></asp:SqlDataSource>
            </div>
        </div>
    </div>
</asp:Content>
